{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>合作方</th>\n",
       "      <th>用户类型</th>\n",
       "      <th>省份</th>\n",
       "      <th>完成时间</th>\n",
       "      <th>账期</th>\n",
       "      <th>逾期期数</th>\n",
       "      <th>逾期人数</th>\n",
       "      <th>总竣工人数</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>1</td>\n",
       "      <td>重庆市</td>\n",
       "      <td>201904</td>\n",
       "      <td>201905</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1987</th>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>201904</td>\n",
       "      <td>201905</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>2430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4521</th>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>201903</td>\n",
       "      <td>201905</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15747</th>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>1</td>\n",
       "      <td>江苏省</td>\n",
       "      <td>201903</td>\n",
       "      <td>201904</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>417</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7684</th>\n",
       "      <td>ZIZHUSHOUXIN</td>\n",
       "      <td>1</td>\n",
       "      <td>广东省</td>\n",
       "      <td>201904</td>\n",
       "      <td>201905</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>1446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8812</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201905</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13940</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201904</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24066</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201903</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34394</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201902</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38261</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201901</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43601</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201812</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47863</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201811</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50347</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201810</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50965</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201810</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53203</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201809</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53292</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201809</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55580</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201806</td>\n",
       "      <td>201808</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201905</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3829</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201905</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6810</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201905</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14242</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201904</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15730</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201904</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20269</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201904</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23564</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201903</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28436</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201903</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35681</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201902</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36390</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201901</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43285</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201812</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49970</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201811</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58506</th>\n",
       "      <td>ZIYING</td>\n",
       "      <td>4</td>\n",
       "      <td>甘肃省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201807</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17517</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201904</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20106</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201904</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23234</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201903</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27197</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201903</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31071</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201902</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32696</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201902</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36777</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201901</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39866</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201901</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44914</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201812</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45357</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201812</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49380</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201811</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51809</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201810</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53541</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201809</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56951</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201807</td>\n",
       "      <td>201808</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2740</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201905</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19331</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201805</td>\n",
       "      <td>201904</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5486</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201905</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13380</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201904</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48111</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201811</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49844</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201811</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50722</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201810</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52574</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201810</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53838</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201809</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56698</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201808</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58503</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201807</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59014</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201806</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59659</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201805</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60182</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201805</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60389</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201804</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60646</th>\n",
       "      <td>BESTPAY</td>\n",
       "      <td>3</td>\n",
       "      <td>云南省</td>\n",
       "      <td>201802</td>\n",
       "      <td>201803</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>60887 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                合作方  用户类型   省份    完成时间      账期  逾期期数  逾期人数  总竣工人数\n",
       "254    ZIZHUSHOUXIN     1  重庆市  201904  201905     1    15    712\n",
       "1987   ZIZHUSHOUXIN     1  江苏省  201904  201905     1     8   2430\n",
       "4521   ZIZHUSHOUXIN     1  江苏省  201903  201905     1     1    417\n",
       "15747  ZIZHUSHOUXIN     1  江苏省  201903  201904     1     1    417\n",
       "7684   ZIZHUSHOUXIN     1  广东省  201904  201905     1    10   1446\n",
       "8812         ZIYING     4  甘肃省  201806  201905    10     1      9\n",
       "13940        ZIYING     4  甘肃省  201806  201904     9     1      9\n",
       "24066        ZIYING     4  甘肃省  201806  201903     8     1      9\n",
       "34394        ZIYING     4  甘肃省  201806  201902     7     1      9\n",
       "38261        ZIYING     4  甘肃省  201806  201901     6     1      9\n",
       "43601        ZIYING     4  甘肃省  201806  201812     5     1      9\n",
       "47863        ZIYING     4  甘肃省  201806  201811     4     1      9\n",
       "50347        ZIYING     4  甘肃省  201806  201810     2     1      9\n",
       "50965        ZIYING     4  甘肃省  201806  201810     3     1      9\n",
       "53203        ZIYING     4  甘肃省  201806  201809     2     1      9\n",
       "53292        ZIYING     4  甘肃省  201806  201809     1     1      9\n",
       "55580        ZIYING     4  甘肃省  201806  201808     1     1      9\n",
       "889          ZIYING     4  甘肃省  201805  201905     3     1     89\n",
       "3829         ZIYING     4  甘肃省  201805  201905     2     2     89\n",
       "6810         ZIYING     4  甘肃省  201805  201905     7     1     89\n",
       "14242        ZIYING     4  甘肃省  201805  201904     2     1     89\n",
       "15730        ZIYING     4  甘肃省  201805  201904     6     1     89\n",
       "20269        ZIYING     4  甘肃省  201805  201904     1     2     89\n",
       "23564        ZIYING     4  甘肃省  201805  201903     5     1     89\n",
       "28436        ZIYING     4  甘肃省  201805  201903     1     1     89\n",
       "35681        ZIYING     4  甘肃省  201805  201902     4     1     89\n",
       "36390        ZIYING     4  甘肃省  201805  201901     3     1     89\n",
       "43285        ZIYING     4  甘肃省  201805  201812     2     1     89\n",
       "49970        ZIYING     4  甘肃省  201805  201811     1     1     89\n",
       "58506        ZIYING     4  甘肃省  201805  201807     1     2     89\n",
       "...             ...   ...  ...     ...     ...   ...   ...    ...\n",
       "17517       BESTPAY     3  云南省  201807  201904     5     1     17\n",
       "20106       BESTPAY     3  云南省  201807  201904     9     1     17\n",
       "23234       BESTPAY     3  云南省  201807  201903     8     1     17\n",
       "27197       BESTPAY     3  云南省  201807  201903     4     1     17\n",
       "31071       BESTPAY     3  云南省  201807  201902     7     1     17\n",
       "32696       BESTPAY     3  云南省  201807  201902     3     1     17\n",
       "36777       BESTPAY     3  云南省  201807  201901     2     1     17\n",
       "39866       BESTPAY     3  云南省  201807  201901     6     1     17\n",
       "44914       BESTPAY     3  云南省  201807  201812     5     1     17\n",
       "45357       BESTPAY     3  云南省  201807  201812     1     1     17\n",
       "49380       BESTPAY     3  云南省  201807  201811     4     1     17\n",
       "51809       BESTPAY     3  云南省  201807  201810     3     1     17\n",
       "53541       BESTPAY     3  云南省  201807  201809     2     1     17\n",
       "56951       BESTPAY     3  云南省  201807  201808     1     1     17\n",
       "2740        BESTPAY     3  云南省  201805  201905     2     1      3\n",
       "19331       BESTPAY     3  云南省  201805  201904     1     1      3\n",
       "5486        BESTPAY     3  云南省  201802  201905     2     1      6\n",
       "13380       BESTPAY     3  云南省  201802  201904     1     1      6\n",
       "48111       BESTPAY     3  云南省  201802  201811     2     1      6\n",
       "49844       BESTPAY     3  云南省  201802  201811     7     1      6\n",
       "50722       BESTPAY     3  云南省  201802  201810     1     1      6\n",
       "52574       BESTPAY     3  云南省  201802  201810     6     1      6\n",
       "53838       BESTPAY     3  云南省  201802  201809     5     1      6\n",
       "56698       BESTPAY     3  云南省  201802  201808     4     1      6\n",
       "58503       BESTPAY     3  云南省  201802  201807     3     1      6\n",
       "59014       BESTPAY     3  云南省  201802  201806     2     1      6\n",
       "59659       BESTPAY     3  云南省  201802  201805     1     1      6\n",
       "60182       BESTPAY     3  云南省  201802  201805     3     1      6\n",
       "60389       BESTPAY     3  云南省  201802  201804     2     1      6\n",
       "60646       BESTPAY     3  云南省  201802  201803     1     1      6\n",
       "\n",
       "[60887 rows x 8 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "vintage = pd.read_csv('vintage_all.csv')\n",
    "vintage.sort_values(['合作方','用户类型','省份','完成时间','账期'],ascending=[0,0,0,0,0],inplace=True)\n",
    "vintage"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
